package com.xcfw.dorm.mapper;

import com.xcfw.dorm.entity.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface StudentMapper {
    int deleteByPrimaryKey(Integer id);

    int insertSelective(Student record);

    Student selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Student record);

    List<Student> selectActionSql(@Param("schoolId") String schoolId,
                                  @Param("name") String name,
                                  @Param("password") String password,
                                  @Param("building") String building,
                                  @Param("identity") String identity,
                                  @Param("floor") String floor,
                                  @Param("dormitory") String dormitory,
                                  @Param("judgeExamine") String judgeExamine);

    Integer selectAutoId();

    Integer selectLogin(@Param("schoolId") String schoolId,
                        @Param("name") String name,
                        @Param("password") String password,
                        @Param("building") String building);

    List<Map<String, String>> selectExcel(@Param("schoolId") String schoolId,
                                          @Param("name") String name,
                                          @Param("password") String password,
                                          @Param("building") String building,
                                          @Param("identity") String identity,
                                          @Param("floor") String floor,
                                          @Param("dormitory") String dormitory,
                                          @Param("judgeExamine") String judgeExamine);
}